<!doctype html>
<html>
<head>
  <title>CodeMirror 2: Oracle PL/SQL mode</title>
  <link rel="stylesheet" href="../../lib/codemirror.css">
  <script src="../../lib/codemirror.js"></script>
  <script src="plsql.js"></script>
  <link rel="stylesheet" href="../../theme/default.css">
  <link rel="stylesheet" href="../../css/docs.css">
  <style>.CodeMirror {
    border: 2px inset #dee;
  }</style>
</head>
<body>
<h1>CodeMirror 2: Oracle PL/SQL mode</h1>

<form><textarea id="code" name="code">
  -- Oracle PL/SQL Code Demo
  /*
  based on c-like mode, adapted to PL/SQL by Peter Raganitsch ( http://www.oracle-and-apex.com/ )
  April 2011
  */
  DECLARE
  vIdx NUMBER;
  vString VARCHAR2(100);
  cText CONSTANT VARCHAR2(100) := 'That''s it! Have fun with CodeMirror 2';
  BEGIN
  vIdx := 0;
  --
  FOR rDATA IN
  ( SELECT *
  FROM EMP
  ORDER BY EMPNO
  )
  LOOP
  vIdx := vIdx + 1;
  vString := rDATA.EMPNO || ' - ' || rDATA.ENAME;
  --
  UPDATE EMP
  SET SAL = SAL * 101/100
  WHERE EMPNO = rDATA.EMPNO
  ;
  END LOOP;
  --
  SYS.DBMS_OUTPUT.Put_Line (cText);
  END;
  --
</textarea></form>

<script>
  var editor = CodeMirror.fromTextArea(document.getElementById("code"), {
    lineNumbers:true,
    matchBrackets:true,
    indentUnit:4,
    mode:"text/x-plsql"
  });
</script>

<p>
  Simple mode that handles Oracle PL/SQL language (and Oracle SQL, of course).
</p>

<p><strong>MIME type defined:</strong> <code>text/x-plsql</code>
  (PLSQL code)
</html>
